NTISthis.com

Evidence Guide: ICTSAS408 - Complete data transition in data migration process

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTSAS408 - Complete data transition in data migration process

What evidence can you provide to prove your understanding of each of the following citeria?

Perform data transition

  1. Identify and document data that is to be migrated, transferred or archived
  2. Collect required data, target database requirements and implementation details
  3. Clean up data to match new data structures and rules
  4. Write and test conversion programs if required by the implementation plan, or use conversion tools
  5. Ensure clean data take-on by re-keying or converting according to database requirements and conversion plan
  6. Migrate data to target environment
  7. Archive data according to requirements
Identify and document data that is to be migrated, transferred or archived

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Collect required data, target database requirements and implementation details

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Clean up data to match new data structures and rules

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Write and test conversion programs if required by the implementation plan, or use conversion tools

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Ensure clean data take-on by re-keying or converting according to database requirements and conversion plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Migrate data to target environment

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Archive data according to requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Check data transition

  1. Run reports and other tests on old and new data to verify the quantity and quality of data transition
  2. Run production or specialised programs against data to confirm control totals
  3. Check referential integrity and data constraints and requirements against database requirements and conversion plan
  4. Verify that data transition has been completed according to requirements and plans
Run reports and other tests on old and new data to verify the quantity and quality of data transition

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Run production or specialised programs against data to confirm control totals

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Check referential integrity and data constraints and requirements against database requirements and conversion plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Verify that data transition has been completed according to requirements and plans

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Perform data transition

1.1 Identify and document data that is to be migrated, transferred or archived

1.2 Collect required data, target database requirements and implementation details

1.3 Clean up data to match new data structures and rules

1.4 Write and test conversion programs if required by the implementation plan, or use conversion tools

1.5 Ensure clean data take-on by re-keying or converting according to database requirements and conversion plan

1.6 Migrate data to target environment

1.7 Archive data according to requirements

2. Check data transition

2.1 Run reports and other tests on old and new data to verify the quantity and quality of data transition

2.2 Run production or specialised programs against data to confirm control totals

2.3 Check referential integrity and data constraints and requirements against database requirements and conversion plan

2.4 Verify that data transition has been completed according to requirements and plans

Required Skills and Knowledge

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Perform data transition

1.1 Identify and document data that is to be migrated, transferred or archived

1.2 Collect required data, target database requirements and implementation details

1.3 Clean up data to match new data structures and rules

1.4 Write and test conversion programs if required by the implementation plan, or use conversion tools

1.5 Ensure clean data take-on by re-keying or converting according to database requirements and conversion plan

1.6 Migrate data to target environment

1.7 Archive data according to requirements

2. Check data transition

2.1 Run reports and other tests on old and new data to verify the quantity and quality of data transition

2.2 Run production or specialised programs against data to confirm control totals

2.3 Check referential integrity and data constraints and requirements against database requirements and conversion plan

2.4 Verify that data transition has been completed according to requirements and plans

Evidence of the ability to:

identify data to be migrated

transfer data from one system to another

produce consistency in results

verify database integrity for transferred data.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

describe current industry accepted hardware and software products, including their general features and capabilities

identify and summarise new and existing systems’ current functionality

describe data management systems when performing data transition, including:

data integrity

database structures

quality assurance practices

software tools

system data requirements

describe the client business domain relevant to data transition

outline client's data management and data security policy and procedures.